
local _M = {}
-- charset key is charset name and value is default collation id
_M.charset_id = {
    big5     =    1,
    dec8     =    3,
    cp850    =    4,
    hp8      =    6,
    koi8r    =    7,
    latin1   =    8,
    latin2   =    9,
    swe7     =    10,
    ascii    =    11,
    ujis     =    12,
    sjis     =    13,
    hebrew   =    16,
    tis620   =    18,
    euckr    =    19,
    koi8u    =    22,
    gb2312   =    24,
    greek    =    25,
    cp1250   =    26,
    gbk      =    28,
    latin5   =    30,
    armscii8 =    32,
    utf8     =    33,
    ucs2     =    35,
    cp866    =    36,
    keybcs2  =    37,
    macce    =    38,
    macroman =    39,
    cp852    =    40,
    latin7   =    41,
    utf8mb4  =    45,
    cp1251   =    51,
    utf16    =    54,
    utf16le  =    56,
    cp1256   =    57,
    cp1257   =    59,
    utf32    =    60,
    binary   =    63,
    geostd8  =    92,
    cp932    =    95,
    eucjpms  =    97,
}

--charset key is charset name and value is default collation name
_M.charsets = {
    big5=     "big5_chinese_ci",
    dec8=     "dec8_swedish_ci",
    cp850=    "cp850_general_ci",
    hp8=      "hp8_english_ci",
    koi8r=    "koi8r_general_ci",
    latin1=   "latin1_swedish_ci",
    latin2=   "latin2_general_ci",
    swe7=     "swe7_swedish_ci",
    ascii=    "ascii_general_ci",
    ujis=     "ujis_japanese_ci",
    sjis=     "sjis_japanese_ci",
    hebrew=   "hebrew_general_ci",
    tis620=   "tis620_thai_ci",
    euckr=    "euckr_korean_ci",
    koi8u=    "koi8u_general_ci",
    gb2312=   "gb2312_chinese_ci",
    greek=    "greek_general_ci",
    cp1250=   "cp1250_general_ci",
    gbk=      "gbk_chinese_ci",
    latin5=   "latin5_turkish_ci",
    armscii8= "armscii8_general_ci",
    utf8=     "utf8_general_ci",
    ucs2=     "ucs2_general_ci",
    cp866=    "cp866_general_ci",
    keybcs2=  "keybcs2_general_ci",
    macce=    "macce_general_ci",
    macroman= "macroman_general_ci",
    cp852=    "cp852_general_ci",
    latin7=   "latin7_general_ci",
    utf8mb4=  "utf8mb4_general_ci",
    cp1251=   "cp1251_general_ci",
    utf16=    "utf16_general_ci",
    utf16le=  "utf16le_general_ci",
    cp1256=   "cp1256_general_ci",
    cp1257=   "cp1257_general_ci",
    utf32=    "utf32_general_ci",
    binary=   "binary",
    geostd8=  "geostd8_general_ci",
    cp932=    "cp932_japanese_ci",
    eucjpms=  "eucjpms_japanese_ci",
}

_M.collations = {
    "big5_chinese_ci",
    "latin2_czech_cs",
    "dec8_swedish_ci",
    "cp850_general_ci",
    "latin1_german1_ci",
    "hp8_english_ci",
    "koi8r_general_ci",
    "latin1_swedish_ci",
    "latin2_general_ci",
    "swe7_swedish_ci",
    "ascii_general_ci",
    "ujis_japanese_ci",
    "sjis_japanese_ci",
    "cp1251_bulgarian_ci",
    "latin1_danish_ci",
    "hebrew_general_ci",
    "tis620_thai_ci",
    "euckr_korean_ci",
    "latin7_estonian_cs",
    "latin2_hungarian_ci",
    "koi8u_general_ci",
    "cp1251_ukrainian_ci",
    "gb2312_chinese_ci",
    "greek_general_ci",
    "cp1250_general_ci",
    "latin2_croatian_ci",
    "gbk_chinese_ci",
    "cp1257_lithuanian_ci",
    "latin5_turkish_ci",
    "latin1_german2_ci",
    "armscii8_general_ci",
    "utf8_general_ci",
    "cp1250_czech_cs",
    "ucs2_general_ci",
    "cp866_general_ci",
    "keybcs2_general_ci",
    "macce_general_ci",
    "macroman_general_ci",
    "cp852_general_ci",
    "latin7_general_ci",
    "latin7_general_cs",
    "macce_bin",
    "cp1250_croatian_ci",
    "utf8mb4_general_ci",
    "utf8mb4_bin",
    "latin1_bin",
    "latin1_general_ci",
    "latin1_general_cs",
    "cp1251_bin",
    "cp1251_general_ci",
    "cp1251_general_cs",
    "macroman_bin",
    "utf16_general_ci",
    "utf16_bin",
    "utf16le_general_ci",
    "cp1256_general_ci",
    "cp1257_bin",
    "cp1257_general_ci",
    "utf32_general_ci",
    "utf32_bin",
    "utf16le_bin",
    "binary",
    "armscii8_bin",
    "ascii_bin",
    "cp1250_bin",
    "cp1256_bin",
    "cp866_bin",
    "dec8_bin",
    "greek_bin",
    "hebrew_bin",
    "hp8_bin",
    "keybcs2_bin",
    "koi8r_bin",
    "koi8u_bin",
    "latin2_bin",
    "latin5_bin",
    "latin7_bin",
    "cp850_bin",
    "cp852_bin",
    "swe7_bin",
    "utf8_bin",
    "big5_bin",
    "euckr_bin",
    "gb2312_bin",
    "gbk_bin",
    "sjis_bin",
    "tis620_bin",
    "ucs2_bin",
    "ujis_bin",
    "geostd8_general_ci",
    "geostd8_bin",
    "latin1_spanish_ci",
    "cp932_japanese_ci",
    "cp932_bin",
    "eucjpms_japanese_ci",
    "eucjpms_bin",
    "cp1250_polish_ci",
    "utf16_unicode_ci",
    "utf16_icelandic_ci",
    "utf16_latvian_ci",
    "utf16_romanian_ci",
    "utf16_slovenian_ci",
    "utf16_polish_ci",
    "utf16_estonian_ci",
    "utf16_spanish_ci",
    "utf16_swedish_ci",
    "utf16_turkish_ci",
    "utf16_czech_ci",
    "utf16_danish_ci",
    "utf16_lithuanian_ci",
    "utf16_slovak_ci",
    "utf16_spanish2_ci",
    "utf16_roman_ci",
    "utf16_persian_ci",
    "utf16_esperanto_ci",
    "utf16_hungarian_ci",
    "utf16_sinhala_ci",
    "utf16_german2_ci",
    "utf16_croatian_ci",
    "utf16_unicode_520_ci",
    "utf16_vietnamese_ci",
    "ucs2_unicode_ci",
    "ucs2_icelandic_ci",
    "ucs2_latvian_ci",
    "ucs2_romanian_ci",
    "ucs2_slovenian_ci",
    "ucs2_polish_ci",
    "ucs2_estonian_ci",
    "ucs2_spanish_ci",
    "ucs2_swedish_ci",
    "ucs2_turkish_ci",
    "ucs2_czech_ci",
    "ucs2_danish_ci",
    "ucs2_lithuanian_ci",
    "ucs2_slovak_ci",
    "ucs2_spanish2_ci",
    "ucs2_roman_ci",
    "ucs2_persian_ci",
    "ucs2_esperanto_ci",
    "ucs2_hungarian_ci",
    "ucs2_sinhala_ci",
    "ucs2_german2_ci",
    "ucs2_croatian_ci",
    "ucs2_unicode_520_ci",
    "ucs2_vietnamese_ci",
    "ucs2_general_mysql500_ci",
    "utf32_unicode_ci",
    "utf32_icelandic_ci",
    "utf32_latvian_ci",
    "utf32_romanian_ci",
    "utf32_slovenian_ci",
    "utf32_polish_ci",
    "utf32_estonian_ci",
    "utf32_spanish_ci",
    "utf32_swedish_ci",
    "utf32_turkish_ci",
    "utf32_czech_ci",
    "utf32_danish_ci",
    "utf32_lithuanian_ci",
    "utf32_slovak_ci",
    "utf32_spanish2_ci",
    "utf32_roman_ci",
    "utf32_persian_ci",
    "utf32_esperanto_ci",
    "utf32_hungarian_ci",
    "utf32_sinhala_ci",
    "utf32_german2_ci",
    "utf32_croatian_ci",
    "utf32_unicode_520_ci",
    "utf32_vietnamese_ci",
    "utf8_unicode_ci",
    "utf8_icelandic_ci",
    "utf8_latvian_ci",
    "utf8_romanian_ci",
    "utf8_slovenian_ci",
    "utf8_polish_ci",
    "utf8_estonian_ci",
    "utf8_spanish_ci",
    "utf8_swedish_ci",
    "utf8_turkish_ci",
    "utf8_czech_ci",
    "utf8_danish_ci",
    "utf8_lithuanian_ci",
    "utf8_slovak_ci",
    "utf8_spanish2_ci",
    "utf8_roman_ci",
    "utf8_persian_ci",
    "utf8_esperanto_ci",
    "utf8_hungarian_ci",
    "utf8_sinhala_ci",
    "utf8_german2_ci",
    "utf8_croatian_ci",
    "utf8_unicode_520_ci",
    "utf8_vietnamese_ci",
    "utf8_general_mysql500_ci",
    "utf8mb4_unicode_ci",
    "utf8mb4_icelandic_ci",
    "utf8mb4_latvian_ci",
    "utf8mb4_romanian_ci",
    "utf8mb4_slovenian_ci",
    "utf8mb4_polish_ci",
    "utf8mb4_estonian_ci",
    "utf8mb4_spanish_ci",
    "utf8mb4_swedish_ci",
    "utf8mb4_turkish_ci",
    "utf8mb4_czech_ci",
    "utf8mb4_danish_ci",
    "utf8mb4_lithuanian_ci",
    "utf8mb4_slovak_ci",
    "utf8mb4_spanish2_ci",
    "utf8mb4_roman_ci",
    "utf8mb4_persian_ci",
    "utf8mb4_esperanto_ci",
    "utf8mb4_hungarian_ci",
    "utf8mb4_sinhala_ci",
    "utf8mb4_german2_ci",
    "utf8mb4_croatian_ci",
    "utf8mb4_unicode_520_ci",
    "utf8mb4_vietnamese_ci",
}

_M.collation_names = {
    big5_chinese_ci=          1,
    latin2_czech_cs=          2,
    dec8_swedish_ci=          3,
    cp850_general_ci=         4,
    latin1_german1_ci=        5,
    hp8_english_ci=           6,
    koi8r_general_ci=         7,
    latin1_swedish_ci=        8,
    latin2_general_ci=        9,
    swe7_swedish_ci=          10,
    ascii_general_ci=         11,
    ujis_japanese_ci=         12,
    sjis_japanese_ci=         13,
    cp1251_bulgarian_ci=      14,
    latin1_danish_ci=         15,
    hebrew_general_ci=        16,
    tis620_thai_ci=           18,
    euckr_korean_ci=          19,
    latin7_estonian_cs=       20,
    latin2_hungarian_ci=      21,
    koi8u_general_ci=         22,
    cp1251_ukrainian_ci=      23,
    gb2312_chinese_ci=        24,
    greek_general_ci=         25,
    cp1250_general_ci=        26,
    latin2_croatian_ci=       27,
    gbk_chinese_ci=           28,
    cp1257_lithuanian_ci=     29,
    latin5_turkish_ci=        30,
    latin1_german2_ci=        31,
    armscii8_general_ci=      32,
    utf8_general_ci=          33,
    cp1250_czech_cs=          34,
    ucs2_general_ci=          35,
    cp866_general_ci=         36,
    keybcs2_general_ci=       37,
    macce_general_ci=         38,
    macroman_general_ci=      39,
    cp852_general_ci=         40,
    latin7_general_ci=        41,
    latin7_general_cs=        42,
    macce_bin=                43,
    cp1250_croatian_ci=       44,
    utf8mb4_general_ci=       45,
    utf8mb4_bin=              46,
    latin1_bin=               47,
    latin1_general_ci=        48,
    latin1_general_cs=        49,
    cp1251_bin=               50,
    cp1251_general_ci=        51,
    cp1251_general_cs=        52,
    macroman_bin=             53,
    utf16_general_ci=         54,
    utf16_bin=                55,
    utf16le_general_ci=       56,
    cp1256_general_ci=        57,
    cp1257_bin=               58,
    cp1257_general_ci=        59,
    utf32_general_ci=         60,
    utf32_bin=                61,
    utf16le_bin=              62,
    binary=                   63,
    armscii8_bin=             64,
    ascii_bin=                65,
    cp1250_bin=               66,
    cp1256_bin=               67,
    cp866_bin=                68,
    dec8_bin=                 69,
    greek_bin=                70,
    hebrew_bin=               71,
    hp8_bin=                  72,
    keybcs2_bin=              73,
    koi8r_bin=                74,
    koi8u_bin=                75,
    latin2_bin=               77,
    latin5_bin=               78,
    latin7_bin=               79,
    cp850_bin=                80,
    cp852_bin=                81,
    swe7_bin=                 82,
    utf8_bin=                 83,
    big5_bin=                 84,
    euckr_bin=                85,
    gb2312_bin=               86,
    gbk_bin=                  87,
    sjis_bin=                 88,
    tis620_bin=               89,
    ucs2_bin=                 90,
    ujis_bin=                 91,
    geostd8_general_ci=       92,
    geostd8_bin=              93,
    latin1_spanish_ci=        94,
    cp932_japanese_ci=        95,
    cp932_bin=                96,
    eucjpms_japanese_ci=      97,
    eucjpms_bin=              98,
    cp1250_polish_ci=         99,
    utf16_unicode_ci=         101,
    utf16_icelandic_ci=       102,
    utf16_latvian_ci=         103,
    utf16_romanian_ci=        104,
    utf16_slovenian_ci=       105,
    utf16_polish_ci=          106,
    utf16_estonian_ci=        107,
    utf16_spanish_ci=         108,
    utf16_swedish_ci=         109,
    utf16_turkish_ci=         110,
    utf16_czech_ci=           111,
    utf16_danish_ci=          112,
    utf16_lithuanian_ci=      113,
    utf16_slovak_ci=          114,
    utf16_spanish2_ci=        115,
    utf16_roman_ci=           116,
    utf16_persian_ci=         117,
    utf16_esperanto_ci=       118,
    utf16_hungarian_ci=       119,
    utf16_sinhala_ci=         120,
    utf16_german2_ci=         121,
    utf16_croatian_ci=        122,
    utf16_unicode_520_ci=     123,
    utf16_vietnamese_ci=      124,
    ucs2_unicode_ci=          128,
    ucs2_icelandic_ci=        129,
    ucs2_latvian_ci=          130,
    ucs2_romanian_ci=         131,
    ucs2_slovenian_ci=        132,
    ucs2_polish_ci=           133,
    ucs2_estonian_ci=         134,
    ucs2_spanish_ci=          135,
    ucs2_swedish_ci=          136,
    ucs2_turkish_ci=          137,
    ucs2_czech_ci=            138,
    ucs2_danish_ci=           139,
    ucs2_lithuanian_ci=       140,
    ucs2_slovak_ci=           141,
    ucs2_spanish2_ci=         142,
    ucs2_roman_ci=            143,
    ucs2_persian_ci=          144,
    ucs2_esperanto_ci=        145,
    ucs2_hungarian_ci=        146,
    ucs2_sinhala_ci=          147,
    ucs2_german2_ci=          148,
    ucs2_croatian_ci=         149,
    ucs2_unicode_520_ci=      150,
    ucs2_vietnamese_ci=       151,
    ucs2_general_mysql500_ci= 159,
    utf32_unicode_ci=         160,
    utf32_icelandic_ci=       161,
    utf32_latvian_ci=         162,
    utf32_romanian_ci=        163,
    utf32_slovenian_ci=       164,
    utf32_polish_ci=          165,
    utf32_estonian_ci=        166,
    utf32_spanish_ci=         167,
    utf32_swedish_ci=         168,
    utf32_turkish_ci=         169,
    utf32_czech_ci=           170,
    utf32_danish_ci=          171,
    utf32_lithuanian_ci=      172,
    utf32_slovak_ci=          173,
    utf32_spanish2_ci=        174,
    utf32_roman_ci=           175,
    utf32_persian_ci=         176,
    utf32_esperanto_ci=       177,
    utf32_hungarian_ci=       178,
    utf32_sinhala_ci=         179,
    utf32_german2_ci=         180,
    utf32_croatian_ci=        181,
    utf32_unicode_520_ci=     182,
    utf32_vietnamese_ci=      183,
    utf8_unicode_ci=          192,
    utf8_icelandic_ci=        193,
    utf8_latvian_ci=          194,
    utf8_romanian_ci=         195,
    utf8_slovenian_ci=        196,
    utf8_polish_ci=           197,
    utf8_estonian_ci=         198,
    utf8_spanish_ci=          199,
    utf8_swedish_ci=          200,
    utf8_turkish_ci=          201,
    utf8_czech_ci=            202,
    utf8_danish_ci=           203,
    utf8_lithuanian_ci=       204,
    utf8_slovak_ci=           205,
    utf8_spanish2_ci=         206,
    utf8_roman_ci=            207,
    utf8_persian_ci=          208,
    utf8_esperanto_ci=        209,
    utf8_hungarian_ci=        210,
    utf8_sinhala_ci=          211,
    utf8_german2_ci=          212,
    utf8_croatian_ci=         213,
    utf8_unicode_520_ci=      214,
    utf8_vietnamese_ci=       215,
    utf8_general_mysql500_ci= 223,
    utf8mb4_unicode_ci=       224,
    utf8mb4_icelandic_ci=     225,
    utf8mb4_latvian_ci=       226,
    utf8mb4_romanian_ci=      227,
    utf8mb4_slovenian_ci=     228,
    utf8mb4_polish_ci=        229,
    utf8mb4_estonian_ci=      230,
    utf8mb4_spanish_ci=       231,
    utf8mb4_swedish_ci=       232,
    utf8mb4_turkish_ci=       233,
    utf8mb4_czech_ci=         234,
    utf8mb4_danish_ci=        235,
    utf8mb4_lithuanian_ci=    236,
    utf8mb4_slovak_ci=        237,
    utf8mb4_spanish2_ci=      238,
    utf8mb4_roman_ci=         239,
    utf8mb4_persian_ci=       240,
    utf8mb4_esperanto_ci=     241,
    utf8mb4_hungarian_ci=     242,
    utf8mb4_sinhala_ci=       243,
    utf8mb4_german2_ci=       244,
    utf8mb4_croatian_ci=      245,
    utf8mb4_unicode_520_ci=   246,
    utf8mb4_vietnamese_ci=    247,
}


_M.DEFAULT_CHARSET         = "utf8"
_M.DEFAULT_COLLATION_ID    = 33
_M.DEFAULT_COLLATION_NAME  = "utf8_general_ci"


return _M